IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[AddArraEmailNotificationStatus]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.AddArraEmailNotificationStatus
END
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[AddArraEmailNotificationStatus]     
(
	@AdmPersonId INT,
	@FirstName VARCHAR(64),
	@LastName VARCHAR(64),
	@EmailAddress VARCHAR(100),
	@EmailType VARCHAR(2),
	@EmailBody VARCHAR(4000),
	@Role VARCHAR(2),
	@Status VARCHAR(2),
	@ReportingPeriodId INT
)                           
AS BEGIN                                
	SET NOCOUNT ON 

	INSERT INTO ArraEmailNotificationStatus
	(
		AdmPersonId,
		FirstName,
		LastName,
		EmailAddress,
		EmailType,
		EmailBody,
		[Role],
		[Status],
		ReportingPeriodId
	)
	VALUES
	(
		@AdmPersonId,
		@FirstName,
		@LastName,
		@EmailAddress,
		@EmailType,
		@EmailBody,
		@Role,
		@Status,
		@ReportingPeriodId
	);


END

--select * from ArraEmailNotificationStatus

